package com.example.demo.entity.mapper;

import com.example.demo.entity.Comment;
import org.apache.ibatis.annotations.*;

@Mapper
public interface CommentMapper {
    @Select("SELECT * FROM t_comment WHERE id=#{id}")
        public Comment findById(Integer id);

   @Insert("INSERT INTO t_comment(a_id, author, content)VALUES (#{aId}, #{author},  #{content})")
    public int insertComment(Comment comment);

   @Update("UPDATE t_comment SET content=#{content} WHERE id={id}")
    public int updateComment(Comment comment);

   @Delete("DELETE FROM t_comment WHERE id=#{id}")
    public int deleteComment(Integer id);
}